24. OLAP Cubes: Slice and Dice
L01-04-Part 3 OLAP Cubes- Slice And Dice
OLAP
QUIZ QUESTION::
Match the OLAP operation to the correct definition.
ANSWER CHOICES:
|
Definition |
Operation |
|---|---|
Reducing N dimensions to N-1 dimensions by restricting one dimension to a single value. |
|
Same dimensions but computing a sub-cube by restricting, some of the values of the dimensions. |
|
Aggregates or combines values and reduces number of rows or columns. |
|
Decomposes values and increases number of rows or columns. |
SOLUTION:
|
Definition |
Operation |
|---|---|
|
Aggregates or combines values and reduces number of rows or columns. |
|
|
Reducing N dimensions to N-1 dimensions by restricting one dimension to a single value. |
|
|
Decomposes values and increases number of rows or columns. |
|
|
Same dimensions but computing a sub-cube by restricting, some of the values of the dimensions. |